IF OBJECT_ID('ssf.job_run_job_as_jobstep_log_info') IS NOT NULL
	DROP VIEW ssf.job_run_job_as_jobstep_log_info
GO

CREATE VIEW ssf.job_run_job_as_jobstep_log_info
AS
SELECT j.*
	, l.*
FROM (
	SELECT *
		, ssf.regex_replace_4000(task_description, '^(\<jobstep_run_id.*?\/\>).*$', '$1') AS jobstep_run_id
	FROM ssf.log_info_all
	WHERE source_object = 'ssf.job_run_job_as_jobstep'
) l
CROSS APPLY ssf.job_parse_jobstep_run_id(jobstep_run_id) j
GO
